CREATE TABLE REGION 
   (	"ID" VARCHAR2(2 BYTE), 
	"NAME" VARCHAR2(50 BYTE), 
	"SO_TRANSFER_FLAG" VARCHAR2(1 BYTE) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;


    CREATE UNIQUE INDEX "REGION_PK" ON "REGION" ("ID") ;


  ALTER TABLE "REGION" ADD CONSTRAINT "REGION_PK" PRIMARY KEY ("ID", "NAME");
  ALTER TABLE "REGION" MODIFY ("NAME" NOT NULL ENABLE);



  REM INSERTING into REGION
SET DEFINE OFF;
Insert into REGION (ID,NAME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('00','ALL','Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into REGION (ID,NAME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('01','NORTH','Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into REGION (ID,NAME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('02','MIDDLE','Y',to_date('04-JUL-14','DD-MON-RR'));
Insert into REGION (ID,NAME,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('03','SOUTH','Y',to_date('04-JUL-14','DD-MON-RR'));